prepare("INSERT INTO class (classid) VALUES (:classid)");
$stmt->bindParam(':classid', $classid);
if ($stmt->execute()) {
$message = "Class added successfully!";
$message_type = "success";
$classid = ''; // Reset form
} else {
$message = "Error adding class. Please try again.";
$message_type = "danger";
}
} elseif ($_POST['action'] == 'edit') {
// Update existing class
$stmt = $DBcon->prepare("UPDATE class SET classid = :classid WHERE sn = :sn");
$stmt->bindParam(':classid', $classid);
$stmt->bindParam(':sn', $sn);
if ($stmt->execute()) {
$message = "Class updated successfully!";
$message_type = "success";
$action = 'add'; // Reset to add mode
$classid = ''; // Reset form
$sn = '';
} else {
$message = "Error updating class. Please try again.";
$message_type = "danger";
}
}
} catch (PDOException $e) {
if ($e->getCode() == 23000) {
$message = "Class ID already exists. Please use a different ID.";
} else {
$message = "Database error: " . $e->getMessage();
}
$message_type = "danger";
}
}
}
}
// Handle delete request
if (isset($_GET['delete'])) {
$delete_id = sanitize_input($_GET['delete']);
try {
$stmt = $DBcon->prepare("DELETE FROM class WHERE sn = :sn");
$stmt->bindParam(':sn', $delete_id);
if ($stmt->execute()) {
$message = "Class deleted successfully!";
$message_type = "success";
} else {
$message = "Error deleting class. Please try again.";
$message_type = "danger";
}
} catch (PDOException $e) {
$message = "Database error: " . $e->getMessage();
$message_type = "danger";
}
}
// Handle edit request
if (isset($_GET['edit'])) {
$edit_id = sanitize_input($_GET['edit']);
try {
$stmt = $DBcon->prepare("SELECT * FROM class WHERE sn = :sn");
$stmt->bindParam(':sn', $edit_id);
$stmt->execute();
if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$sn = $row['sn'];
$classid = $row['classid'];
$action = 'edit';
} else {
$message = "Class not found.";
$message_type = "danger";
}
} catch (PDOException $e) {
$message = "Database error: " . $e->getMessage();
$message_type = "danger";
}
}
// Fetch all classes for display
$classes = [];
try {
$stmt = $DBcon->prepare("SELECT * FROM class ORDER BY sn");
$stmt->execute();
$classes = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$message = "Error fetching classes: " . $e->getMessage();
$message_type = "danger";
}
?>
Class List
No classes found. Add your first class above.
| # |
Class ID |
Actions |
$class): ?>
|
|
|